package com.wanho.qz103.hrsaas.sys.dao.impl;

import com.wanho.qz103.hrsaas.commons.annontations.Repository;
import com.wanho.qz103.hrsaas.commons.dao.impl.BaseDAOImpl;
import com.wanho.qz103.hrsaas.sys.dao.JobDAO;
import com.wanho.qz103.hrsaas.sys.pojos.Job;

@Repository
public class JobDAOImpl extends BaseDAOImpl<Job> implements JobDAO {
    @Override
    protected String deleteSQL() {
        return null;
    }

    @Override
    protected String insertSQL() {
        return null;
    }

    @Override
    protected String updateSQL() {
        return null;
    }

    @Override
    protected String selectByIdSQL() {
        return "SELECT\n" +
                "    userId,\n" +
                "    adjustmentAgedays,\n" +
                "    adjustmentOfLengthOfService,\n" +
                "    closingTimeOfCurrentContract,\n" +
                "    contractDocuments,\n" +
                "    contractPeriod,\n" +
                "    correctionEvaluation,\n" +
                "    currentContractStartTime,\n" +
                "    firstContractTerminationTime,\n" +
                "    HRBP,\n" +
                "    initialContractStartTime,\n" +
                "    otherRecruitmentChannels,\n" +
                "    post,\n" +
                "    `rank`,\n" +
                "    recommenderBusinessPeople,\n" +
                "    recruitmentChannels,\n" +
                "    renewalNumber,\n" +
                "    reportId,\n" +
                "    reportName,\n" +
                "    socialRecruitment,\n" +
                "    stateOfCorrection,\n" +
                "    taxableCity,\n" +
                "    workMailbox,\n" +
                "    workingCity,\n" +
                "    workingTimeForTheFirstTime\n" +
                "FROM\n" +
                "    sys_employees_job where userId=#{userId}";
    }
}
